package cn.edu.buu.hospital.mapper;

import cn.edu.buu.hospital.entity.Department;
import java.util.List;

public interface DepartmentMapper {
    // 添加科室
    int insert(Department department);
    
    // 查询所有科室
    List<Department> selectAll();
    
    // 根据ID查询科室
    Department selectById(Long deptid);
    
    // 根据医院ID查询科室
    List<Department> selectByHospitalId(Long hospitalid);
    
    // 更新科室信息
    int update(Department department);
    
    // 根据ID删除科室
    int deleteById(Long deptid);
    
    // 查询最新指定数量的科室
    List<Department> selectTopNum(Integer num);
    
    // 查询科室总数
    Long selectTotal();

    List<Department> selectByCondition(Department condition);
}